--SELECT * FROM cat_resumevisibility_r
--DELETE FROM cat_resumevisibility_r
INSERT INTO cv_resumevisibility_r
SELECT
newid() AS [Id],resumeid AS [ResumeId], 
'edu' AS [Subject],
lov.name AS [Name],
lov.value AS [Value]
FROM cv_education edu left join sys_lov lov
on edu.educationlevel = lov.value
order by resumeid


INSERT INTO cv_resumevisibility_r
SELECT
newid() AS [Id],resumeid AS [ResumeId], 
'major' AS [Subject],
lov.name AS [Name],
edu.Major1 AS [Value]
FROM cv_education edu left join sys_lov lov
on edu.major1 = lov.value
order by resumeid
